home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
JCSM Shareware Collection 1993 November
/
JCSM Shareware Collection - 1993-11.iso
/
cl720
/
vxbase1j.lzh
/
VXBTUT0.FRM
(
.txt
)
< prev
next >
Wrap
Visual Basic Form
|
1993-03-04
|
8KB
|
234 lines
vxbtut0
Business Card Directory
Form1%
StatBar
menu0
&File
OpenFile
&Open
SepBar1
ExitMenu
&Exit
menu1
&Maintenance
PackFile
&Pack
CmdTest
&Test
StatBar_Changef
ExitMenu_Click]
vxbtut0
Form_Click
Form_Unload
Cancel
vxDeallocate
Form_Load
vxInitx
vxSetLocks
FALSE$
vxCloseAll
NewFile
vxFile
MasterFile
FileStruc
BFile
Fld01
Fld02
Fld03
Fld04
Fld05
Fld06
Fld07
Fld08
Fld09
Fld10
Fld11
Fld12
Fld13
Fld14
Fld15N
vxCreateDbf
Form_Paint
vxFormFrame
hWndZ
vxCtlStyle
StatBar+
VX_RECESS
DbfArea
OpenFile_Clicku
vxUseDbfw
NtxArea1
vxCreateNtx
NtxArea2
vxUseNtx
vxbtut1
OpenFilef
Enabled
ExitMenu
vxFilterO
vxTopL
vxEof
EditMode
ADDING
vxbtut2
vxCtlGraySet:
vxCtlGrayResets
vxSetStringY
vxSetMeters
PackFile_Click
vxAreaDbf
vxNumRecs
vxPack
vxClose^
aborted
simply
MousePointer
vxSelectDbfP
vxSelectNtxc
vxSetSelect
vxUnlockB
StateDbf
StateNtx
vxTableDeclareo
VX_GRAY4
vxTableField`
VX_FIELD'
vxBrowsePos
vxBrowseSetup
VX_SEMIBOLD
BrowseRunning
Form_QueryUnload
UnloadMode
vxSetLanguage
VX_GERMAN
VX_ENGLISH
Form_DragOver
Source
Control
State8
CmdTest_Click
menu0_Click
SepBar1_Click
vxSeek
vxUseDbfRO
vxCloseNtxx
vxMemCompact
vxSetAnsi
ExitMenu_Click
when exit menu item clicked, unload
controller form: cleanup code is in
form_unload procedure
Form_Load
initialize vxBase
register task
VB strings
clipper locking
reset system gray
and again in case
other apps runninga
browse not active
Form_Paint
for a new file if neededf
make form 3-d
test for existence of master file
and create if necessary
\vb\vxbtest\vxcard.dbf
File does not exist. Make?
Creating new master file
1234567890123456
COMPANY C 40 0
NAME C 40 0
TITLE C 40 0
ADDRESS1 C 40 0
ADDRESS2 C 40 0
CITY C 30 0
STATE C 25 0
COUNTRY C 25 0
ZIPCODE C 10 0
ACTIVITY C 40 0
PHONE C 20 0
FAX C 20 0
CDATE D 8 0
ACCESSES N 5 0
BMEMO M 10 0
\vb\vxbtest\vxcard.dbf
Could not create master file
end if user does not want new file
Form_QueryUnload
VB 2.0 routine to ensure browse is closed
before the user terminates the application
Close Browse first
Form_Unload
clean up memory for vxbaseb
for safety's sake
reset system gray
OpenFile_Click
open file and create indexes if necessary
\vb\vxbtest\vxcard.dbf
Error opening file. Aborting
test for existence of ntx files and createe
if necessary or else just open
\vb\vxbtest\vxcard1.ntx
\vb\vxbtest\vxcard1.ntx
upper(company)
\vb\vxbtest\vxcard1.ntx
Error opening index 1. Aborting.
closes any open files
\vb\vxbtest\vxcard2.ntx
\vb\vxbtest\vxcard2.ntx
upper(activity)+upper(company)
\vb\vxbtest\vxcard2.ntx
Error opening index 2. Aborting.
open state codes file for a help list
\vb\vxbtest\states.dbf
\vb\vxbtest\state1.ntx
set up statesfile browser
statecode
statename
select the master filef
if no legit records then execute add routinee
.NOT. deleted()
set deleted one
data entry form is modal
if user cancelled addition then there
still won't be any records so we go
back to the menuh
No Records to browse.
close the files
open the browse windown
PackFile_Click
remove logically deleted recordso
and reindex
if file doesn't exist, exit
\vb\vxbtest\vxcard.dbf
make sure file isn't open in any task
\vb\vxbtest\vxcard.dbf
open dbf and index filesx
\vb\vxbtest\vxcard.dbf
Error opening file. Aborting
if no records yet, exit herei
\vb\vxbtest\vxcard1.ntx
Error opening index 1. Aborting.
\vb\vxbtest\vxcard2.ntx
Error opening index 2. Aborting.
if less than 100 records then
turn meter bars off because they come and
go so quickly they confuse the user
change MousePointer to Hourglassu
Pack file. File is automatically locked
for the duration. Pack also reindexes.d
Pack failed!
Pack successful!
if the meters were off, the msgbox
tells the user that the operation ist
completeo
If another workstation had the file open,
the vxBase lock attempt would fail and thea
user would be given the opportunity ton
try again or abort the operation. Ifi
aborted, the pack returns FALSE and we
simply close the files and return tot
the menu.
turn meter bars back on
change MousePointer back to arrow